Pandas Profiling Report

Dataset statistics

Number of variables	13
Number of observations	6999
Missing cells	203
Missing cells (%)	0.2%
Duplicate rows	493
Duplicate rows (%)	7.0%
Total size in memory	711.0 KiB
Average record size in memory	104.0 B

Variable types

Text	2
Numeric	7
Categorical	4

Alerts

Dataset has 493 (7.0%) duplicate rows	Duplicates
`engine` is highly overall correlated with `max_power` and 1 other fields	High correlation
`km_driven` is highly overall correlated with `year`	High correlation
`max_power` is highly overall correlated with `engine` and 2 other fields	High correlation
`seats` is highly overall correlated with `engine`	High correlation
`selling_price` is highly overall correlated with `max_power` and 2 other fields	High correlation
`transmission` is highly overall correlated with `max_power` and 1 other fields	High correlation
`year` is highly overall correlated with `km_driven` and 1 other fields	High correlation
`seller_type` is highly imbalanced (51.8%)	Imbalance
`torque` has 203 (2.9%) missing values	Missing

Reproduction

Analysis started	2024-12-03 19:46:10.054480
Analysis finished	2024-12-03 19:46:26.391366
Duration	16.34 seconds
Software version	ydata-profiling vv4.12.0
Download configuration	config.json

name
Text

Distinct	1924
Distinct (%)	27.5%
Missing	0
Missing (%)	0.0%
Memory size	54.8 KiB

Length

Max length	54
Median length	42
Mean length	25.227747
Min length	11

Characters and Unicode

Total characters	176569
Distinct characters	68
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	804 ?
Unique (%)	11.5%

Sample

1st row	Maruti Swift Dzire VDI
2nd row	Skoda Rapid 1.5 TDI Ambition
3rd row	Hyundai i20 Sportz Diesel
4th row	Maruti Swift VXI BSIII
5th row	Hyundai Xcent 1.2 VTVT E Plus

Value	Count	Frequency (%)
maruti	2126	6.4%
hyundai	1197	3.6%
swift	689	2.1%
mahindra	666	2.0%
bsiv	622	1.9%
tata	611	1.8%
diesel	583	1.8%
1.2	505	1.5%
vxi	485	1.5%
plus	459	1.4%
Other values (828)	25224	76.1%

Most occurring characters

Value	Count	Frequency (%)
	26169	14.8%
a	12741	7.2%
i	11534	6.5%
t	8812	5.0%
r	7759	4.4%
o	7165	4.1%
n	6573	3.7%
e	6564	3.7%
u	5091	2.9%
S	4755	2.7%
Other values (58)	79406	45.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	176569	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	26169	14.8%
a	12741	7.2%
i	11534	6.5%
t	8812	5.0%
r	7759	4.4%
o	7165	4.1%
n	6573	3.7%
e	6564	3.7%
u	5091	2.9%
S	4755	2.7%
Other values (58)	79406	45.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	176569	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	26169	14.8%
a	12741	7.2%
i	11534	6.5%
t	8812	5.0%
r	7759	4.4%
o	7165	4.1%
n	6573	3.7%
e	6564	3.7%
u	5091	2.9%
S	4755	2.7%
Other values (58)	79406	45.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	176569	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	26169	14.8%
a	12741	7.2%
i	11534	6.5%
t	8812	5.0%
r	7759	4.4%
o	7165	4.1%
n	6573	3.7%
e	6564	3.7%
u	5091	2.9%
S	4755	2.7%
Other values (58)	79406	45.0%

year
Real number (ℝ)

High correlation

Distinct	29
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2013.8184

Minimum	1983
Maximum	2020
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	54.8 KiB

Quantile statistics

Minimum	1983
5-th percentile	2006
Q1	2011
median	2015
Q3	2017
95-th percentile	2019
Maximum	2020
Range	37
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	4.0530948
Coefficient of variation (CV)	0.0020126417
Kurtosis	1.7672148
Mean	2013.8184
Median Absolute Deviation (MAD)	3
Skewness	-1.0773023
Sum	14094715
Variance	16.427578
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=29)

Value	Count	Frequency (%)
2017	870	12.4%
2016	736	10.5%
2018	704	10.1%
2015	662	9.5%
2013	581	8.3%
2012	563	8.0%
2014	532	7.6%
2019	511	7.3%
2011	499	7.1%
2010	336	4.8%
Other values (19)	1005	14.4%

Value	Count	Frequency (%)
1983	1	< 0.1%
1991	1	< 0.1%
1994	3	< 0.1%
1995	1	< 0.1%
1996	3	< 0.1%
1997	10	0.1%
1998	9	0.1%
1999	13	0.2%
2000	21	0.3%
2001	8	0.1%

Value	Count	Frequency (%)
2020	69	1.0%
2019	511	7.3%
2018	704	10.1%
2017	870	12.4%
2016	736	10.5%
2015	662	9.5%
2014	532	7.6%
2013	581	8.3%
2012	563	8.0%
2011	499	7.1%

selling_price
Real number (ℝ)

High correlation

Distinct	637
Distinct (%)	9.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	639515.2

Minimum	29999
Maximum	10000000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	54.8 KiB

Quantile statistics

Minimum	29999
5-th percentile	110000
Q1	254999
median	450000
Q3	675000
95-th percentile	1925000
Maximum	10000000
Range	9970001
Interquartile range (IQR)	420001

Descriptive statistics

Standard deviation	808941.91
Coefficient of variation (CV)	1.2649299
Kurtosis	21.308644
Mean	639515.2
Median Absolute Deviation (MAD)	200000
Skewness	4.2107557
Sum	4.4759669 × 10⁹
Variance	6.5438702 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
300000	196	2.8%
600000	181	2.6%
450000	178	2.5%
350000	178	2.5%
550000	175	2.5%
650000	161	2.3%
400000	153	2.2%
250000	153	2.2%
500000	152	2.2%
200000	138	2.0%
Other values (627)	5334	76.2%

Value	Count	Frequency (%)
29999	1	< 0.1%
30000	2	< 0.1%
31504	1	< 0.1%
35000	3	< 0.1%
39000	1	< 0.1%
40000	12	0.2%
42000	2	< 0.1%
45000	16	0.2%
45957	2	< 0.1%
50000	15	0.2%

Value	Count	Frequency (%)
10000000	1	< 0.1%
7200000	1	< 0.1%
6523000	1	< 0.1%
6223000	1	< 0.1%
6000000	4	0.1%
5923000	1	< 0.1%
5850000	1	< 0.1%
5830000	2	< 0.1%
5800000	2	< 0.1%
5500000	27	0.4%

km_driven
Real number (ℝ)

High correlation

Distinct	827
Distinct (%)	11.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	69584.616

Minimum	1
Maximum	2360457
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	54.8 KiB

Quantile statistics

Minimum	1
5-th percentile	9000
Q1	35000
median	60000
Q3	97000
95-th percentile	150000
Maximum	2360457
Range	2360456
Interquartile range (IQR)	62000

Descriptive statistics

Standard deviation	57724.002
Coefficient of variation (CV)	0.82955121
Kurtosis	410.79799
Mean	69584.616
Median Absolute Deviation (MAD)	30000
Skewness	12.069152
Sum	4.8702272 × 10⁸
Variance	3.3320604 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
120000	464	6.6%
70000	389	5.6%
80000	387	5.5%
60000	367	5.2%
50000	343	4.9%
100000	306	4.4%
90000	291	4.2%
110000	264	3.8%
40000	260	3.7%
30000	215	3.1%
Other values (817)	3713	53.1%

Value	Count	Frequency (%)
1	1	< 0.1%
1000	6	0.1%
1300	1	< 0.1%
1303	4	0.1%
1500	3	< 0.1%
1600	1	< 0.1%
1620	1	< 0.1%
2000	28	0.4%
2118	1	< 0.1%
2136	1	< 0.1%

Value	Count	Frequency (%)
2360457	1	< 0.1%
1500000	1	< 0.1%
577414	1	< 0.1%
500000	2	< 0.1%
475000	1	< 0.1%
440000	1	< 0.1%
426000	1	< 0.1%
380000	1	< 0.1%
376412	1	< 0.1%
370000	1	< 0.1%

fuel
Categorical

Distinct	4
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	54.8 KiB

Diesel	3793
Petrol	3120
CNG	52
LPG	34

Length

Max length	6
Median length	6
Mean length	5.9631376
Min length	3

Characters and Unicode

Total characters	41736
Distinct characters	13
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Diesel
2nd row	Diesel
3rd row	Diesel
4th row	Petrol
5th row	Petrol

Common Values

Value	Count	Frequency (%)
Diesel	3793	54.2%
Petrol	3120	44.6%
CNG	52	0.7%
LPG	34	0.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
diesel	3793	54.2%
petrol	3120	44.6%
cng	52	0.7%
lpg	34	0.5%

Most occurring characters

Value	Count	Frequency (%)
e	10706	25.7%
l	6913	16.6%
D	3793	9.1%
i	3793	9.1%
s	3793	9.1%
P	3154	7.6%
t	3120	7.5%
r	3120	7.5%
o	3120	7.5%
G	86	0.2%
Other values (3)	138	0.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	41736	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	10706	25.7%
l	6913	16.6%
D	3793	9.1%
i	3793	9.1%
s	3793	9.1%
P	3154	7.6%
t	3120	7.5%
r	3120	7.5%
o	3120	7.5%
G	86	0.2%
Other values (3)	138	0.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	41736	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	10706	25.7%
l	6913	16.6%
D	3793	9.1%
i	3793	9.1%
s	3793	9.1%
P	3154	7.6%
t	3120	7.5%
r	3120	7.5%
o	3120	7.5%
G	86	0.2%
Other values (3)	138	0.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	41736	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	10706	25.7%
l	6913	16.6%
D	3793	9.1%
i	3793	9.1%
s	3793	9.1%
P	3154	7.6%
t	3120	7.5%
r	3120	7.5%
o	3120	7.5%
G	86	0.2%
Other values (3)	138	0.3%

seller_type
Categorical

Imbalance

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	54.8 KiB

Individual	5826
Dealer	967
Trustmark Dealer	206

Length

Max length	16
Median length	10
Mean length	9.6239463
Min length	6

Characters and Unicode

Total characters	67358
Distinct characters	17
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Individual
2nd row	Individual
3rd row	Individual
4th row	Individual
5th row	Individual

Common Values

Value	Count	Frequency (%)
Individual	5826	83.2%
Dealer	967	13.8%
Trustmark Dealer	206	2.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
individual	5826	80.9%
dealer	1173	16.3%
trustmark	206	2.9%

Most occurring characters

Value	Count	Frequency (%)
d	11652	17.3%
i	11652	17.3%
a	7205	10.7%
l	6999	10.4%
u	6032	9.0%
I	5826	8.6%
v	5826	8.6%
n	5826	8.6%
e	2346	3.5%
r	1585	2.4%
Other values (7)	2409	3.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	67358	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
d	11652	17.3%
i	11652	17.3%
a	7205	10.7%
l	6999	10.4%
u	6032	9.0%
I	5826	8.6%
v	5826	8.6%
n	5826	8.6%
e	2346	3.5%
r	1585	2.4%
Other values (7)	2409	3.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	67358	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
d	11652	17.3%
i	11652	17.3%
a	7205	10.7%
l	6999	10.4%
u	6032	9.0%
I	5826	8.6%
v	5826	8.6%
n	5826	8.6%
e	2346	3.5%
r	1585	2.4%
Other values (7)	2409	3.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	67358	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
d	11652	17.3%
i	11652	17.3%
a	7205	10.7%
l	6999	10.4%
u	6032	9.0%
I	5826	8.6%
v	5826	8.6%
n	5826	8.6%
e	2346	3.5%
r	1585	2.4%
Other values (7)	2409	3.6%

transmission
Categorical

High correlation

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	54.8 KiB

Manual	6095
Automatic	904

Length

Max length	9
Median length	6
Mean length	6.3874839
Min length	6

Characters and Unicode

Total characters	44706
Distinct characters	11
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Manual
2nd row	Manual
3rd row	Manual
4th row	Manual
5th row	Manual

Common Values

Value	Count	Frequency (%)
Manual	6095	87.1%
Automatic	904	12.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
manual	6095	87.1%
automatic	904	12.9%

Most occurring characters

Value	Count	Frequency (%)
a	13094	29.3%
u	6999	15.7%
M	6095	13.6%
n	6095	13.6%
l	6095	13.6%
t	1808	4.0%
A	904	2.0%
o	904	2.0%
m	904	2.0%
i	904	2.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	44706	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	13094	29.3%
u	6999	15.7%
M	6095	13.6%
n	6095	13.6%
l	6095	13.6%
t	1808	4.0%
A	904	2.0%
o	904	2.0%
m	904	2.0%
i	904	2.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	44706	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	13094	29.3%
u	6999	15.7%
M	6095	13.6%
n	6095	13.6%
l	6095	13.6%
t	1808	4.0%
A	904	2.0%
o	904	2.0%
m	904	2.0%
i	904	2.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	44706	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	13094	29.3%
u	6999	15.7%
M	6095	13.6%
n	6095	13.6%
l	6095	13.6%
t	1808	4.0%
A	904	2.0%
o	904	2.0%
m	904	2.0%
i	904	2.0%

owner
Categorical

Distinct	5
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	54.8 KiB

First Owner	4587
Second Owner	1791
Third Owner	473
Fourth & Above Owner	144
Test Drive Car	4

Length

Max length	20
Median length	11
Mean length	11.442778
Min length	11

Characters and Unicode

Total characters	80088
Distinct characters	24
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	First Owner
2nd row	Second Owner
3rd row	First Owner
4th row	First Owner
5th row	First Owner

Common Values

Value	Count	Frequency (%)
First Owner	4587	65.5%
Second Owner	1791	25.6%
Third Owner	473	6.8%
Fourth & Above Owner	144	2.1%
Test Drive Car	4	0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
owner	6995	49.0%
first	4587	32.1%
second	1791	12.5%
third	473	3.3%
fourth	144	1.0%
	144	1.0%
above	144	1.0%
test	4	< 0.1%
drive	4	< 0.1%
car	4	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
r	12207	15.2%
e	8938	11.2%
n	8786	11.0%
	7291	9.1%
O	6995	8.7%
w	6995	8.7%
i	5064	6.3%
t	4735	5.9%
F	4731	5.9%
s	4591	5.7%
Other values (14)	9755	12.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	80088	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
r	12207	15.2%
e	8938	11.2%
n	8786	11.0%
	7291	9.1%
O	6995	8.7%
w	6995	8.7%
i	5064	6.3%
t	4735	5.9%
F	4731	5.9%
s	4591	5.7%
Other values (14)	9755	12.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	80088	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
r	12207	15.2%
e	8938	11.2%
n	8786	11.0%
	7291	9.1%
O	6995	8.7%
w	6995	8.7%
i	5064	6.3%
t	4735	5.9%
F	4731	5.9%
s	4591	5.7%
Other values (14)	9755	12.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	80088	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
r	12207	15.2%
e	8938	11.2%
n	8786	11.0%
	7291	9.1%
O	6995	8.7%
w	6995	8.7%
i	5064	6.3%
t	4735	5.9%
F	4731	5.9%
s	4591	5.7%
Other values (14)	9755	12.2%

mileage
Real number (ℝ)

Distinct	375
Distinct (%)	5.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	19.42295

Minimum	0
Maximum	42
Zeros	16
Zeros (%)	0.2%
Negative	0
Negative (%)	0.0%
Memory size	54.8 KiB

Quantile statistics

Minimum	0
5-th percentile	12.99
Q1	16.8
median	19.3
Q3	22.15
95-th percentile	25.83
Maximum	42
Range	42
Interquartile range (IQR)	5.35

Descriptive statistics

Standard deviation	3.9869306
Coefficient of variation (CV)	0.20526905
Kurtosis	0.78610405
Mean	19.42295
Median Absolute Deviation (MAD)	2.7
Skewness	-0.15084575
Sum	135941.23
Variance	15.895616
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
19.3	259	3.7%
18.9	197	2.8%
19.7	150	2.1%
18.6	139	2.0%
21.1	131	1.9%
17	116	1.7%
15.96	105	1.5%
17.8	101	1.4%
22	99	1.4%
12.99	95	1.4%
Other values (365)	5607	80.1%

Value	Count	Frequency (%)
0	16	0.2%
9	4	0.1%
9.5	5	0.1%
10	2	< 0.1%
10.1	2	< 0.1%
10.5	14	0.2%
10.71	1	< 0.1%
10.75	2	< 0.1%
10.8	1	< 0.1%
10.9	4	0.1%

Value	Count	Frequency (%)
42	1	< 0.1%
33.44	3	< 0.1%
33	1	< 0.1%
32.52	1	< 0.1%
30.46	2	< 0.1%
28.4	80	1.1%
28.09	36	0.5%
27.62	5	0.1%
27.4	6	0.1%
27.39	49	0.7%

engine
Real number (ℝ)

High correlation

Distinct	120
Distinct (%)	1.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1452.2569

Minimum	624
Maximum	3604
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	54.8 KiB

Quantile statistics

Minimum	624
5-th percentile	796
Q1	1197
median	1248
Q3	1582
95-th percentile	2498
Maximum	3604
Range	2980
Interquartile range (IQR)	385

Descriptive statistics

Standard deviation	495.1513
Coefficient of variation (CV)	0.34095297
Kurtosis	0.86257694
Mean	1452.2569
Median Absolute Deviation (MAD)	245
Skewness	1.1818336
Sum	10164346
Variance	245174.81
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1248	1087	15.5%
1197	715	10.2%
998	393	5.6%
796	375	5.4%
2179	330	4.7%
1498	318	4.5%
1396	264	3.8%
1199	233	3.3%
2494	188	2.7%
2523	171	2.4%
Other values (110)	2925	41.8%

Value	Count	Frequency (%)
624	16	0.2%
793	5	0.1%
796	375	5.4%
799	66	0.9%
814	99	1.4%
909	2	< 0.1%
936	31	0.4%
993	24	0.3%
995	41	0.6%
998	393	5.6%

Value	Count	Frequency (%)
3604	5	0.1%
3498	1	< 0.1%
3198	3	< 0.1%
2999	3	< 0.1%
2997	2	< 0.1%
2993	14	0.2%
2987	9	0.1%
2982	28	0.4%
2967	9	0.1%
2956	15	0.2%

max_power
Real number (ℝ)

High correlation

Distinct	312
Distinct (%)	4.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	91.302923

Minimum	32.8
Maximum	400
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	54.8 KiB

Quantile statistics

Minimum	32.8
5-th percentile	47.3
Q1	68.085
median	82
Q3	100.6
95-th percentile	171.5
Maximum	400
Range	367.2
Interquartile range (IQR)	32.515

Descriptive statistics

Standard deviation	35.24864
Coefficient of variation (CV)	0.38606256
Kurtosis	4.1427826
Mean	91.302923
Median Absolute Deviation (MAD)	14.95
Skewness	1.7026217
Sum	639029.16
Variance	1242.4666
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
74	330	4.7%
82	300	4.3%
81.8	193	2.8%
88.5	189	2.7%
67	149	2.1%
46.3	139	2.0%
62.1	130	1.9%
67.1	127	1.8%
67.04	126	1.8%
88.7	125	1.8%
Other values (302)	5191	74.2%

Value	Count	Frequency (%)
32.8	2	< 0.1%
34.2	19	0.3%
35	16	0.2%
35.5	2	< 0.1%
37	74	1.1%
37.48	8	0.1%
37.5	6	0.1%
38	1	< 0.1%
38.4	2	< 0.1%
40.3	3	< 0.1%

Value	Count	Frequency (%)
400	1	< 0.1%
282	1	< 0.1%
280	5	0.1%
272	1	< 0.1%
270.9	3	< 0.1%
265	1	< 0.1%
261.4	6	0.1%
258	2	< 0.1%
254.8	3	< 0.1%
254.79	1	< 0.1%

torque
Text

Missing

Distinct	419
Distinct (%)	6.2%
Missing	203
Missing (%)	2.9%
Memory size	54.8 KiB

Length

Max length	27
Median length	25
Mean length	16.250441
Min length	5

Characters and Unicode

Total characters	110438
Distinct characters	34
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	100 ?
Unique (%)	1.5%

Sample

1st row	190Nm@ 2000rpm
2nd row	250Nm@ 1500-2500rpm
3rd row	22.4 kgm at 1750-2750rpm
4th row	11.5@ 4,500(kgm@ rpm)
5th row	113.75nm@ 4000rpm

Value	Count	Frequency (%)
4000rpm	740	5.2%
2000rpm	688	4.8%
3500rpm	630	4.4%
200nm	596	4.2%
190nm	528	3.7%
1750rpm	483	3.4%
rpm	452	3.1%
90nm	353	2.5%
3000rpm	285	2.0%
4200rpm	269	1.9%
Other values (409)	9336	65.0%

Most occurring characters

Value	Count	Frequency (%)
0	22916	20.8%
m	13512	12.2%
	7591	6.9%
1	7473	6.8%
@	6915	6.3%
r	6744	6.1%
p	6744	6.1%
N	6130	5.6%
2	5896	5.3%
5	5328	4.8%
Other values (24)	21189	19.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	110438	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	22916	20.8%
m	13512	12.2%
	7591	6.9%
1	7473	6.8%
@	6915	6.3%
r	6744	6.1%
p	6744	6.1%
N	6130	5.6%
2	5896	5.3%
5	5328	4.8%
Other values (24)	21189	19.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	110438	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	22916	20.8%
m	13512	12.2%
	7591	6.9%
1	7473	6.8%
@	6915	6.3%
r	6744	6.1%
p	6744	6.1%
N	6130	5.6%
2	5896	5.3%
5	5328	4.8%
Other values (24)	21189	19.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	110438	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	22916	20.8%
m	13512	12.2%
	7591	6.9%
1	7473	6.8%
@	6915	6.3%
r	6744	6.1%
p	6744	6.1%
N	6130	5.6%
2	5896	5.3%
5	5328	4.8%
Other values (24)	21189	19.2%

seats
Real number (ℝ)

High correlation

Distinct	9
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.4069153

Minimum	2
Maximum	14
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	54.8 KiB

Quantile statistics

Minimum	2
5-th percentile	5
Q1	5
median	5
Q3	5
95-th percentile	7
Maximum	14
Range	12
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.95430803
Coefficient of variation (CV)	0.17649769
Kurtosis	4.2811184
Mean	5.4069153
Median Absolute Deviation (MAD)	0
Skewness	2.0598916
Sum	37843
Variance	0.91070382
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=9)

Value	Count	Frequency (%)
5	5595	79.9%
7	944	13.5%
8	208	3.0%
4	104	1.5%
9	72	1.0%
6	54	0.8%
10	19	0.3%
2	2	< 0.1%
14	1	< 0.1%

Value	Count	Frequency (%)
2	2	< 0.1%
4	104	1.5%
5	5595	79.9%
6	54	0.8%
7	944	13.5%
8	208	3.0%
9	72	1.0%
10	19	0.3%
14	1	< 0.1%

Value	Count	Frequency (%)
14	1	< 0.1%
10	19	0.3%
9	72	1.0%
8	208	3.0%
7	944	13.5%
6	54	0.8%
5	5595	79.9%
4	104	1.5%
2	2	< 0.1%

	engine	fuel	km_driven	max_power	mileage	owner	seats	seller_type	selling_price	transmission	year
engine	1.000	0.437	0.237	0.732	-0.456	0.084	0.511	0.229	0.500	0.488	-0.003
fuel	0.437	1.000	0.035	0.206	0.297	0.031	0.210	0.108	0.110	0.050	0.122
km_driven	0.237	0.035	1.000	-0.033	-0.154	0.034	0.215	0.018	-0.358	0.027	-0.620
max_power	0.732	0.206	-0.033	1.000	-0.344	0.086	0.275	0.248	0.650	0.597	0.213
mileage	-0.456	0.297	-0.154	-0.344	1.000	0.089	-0.434	0.072	-0.028	0.214	0.294
owner	0.084	0.031	0.034	0.086	0.089	1.000	0.029	0.169	0.364	0.169	0.269
seats	0.511	0.210	0.215	0.275	-0.434	0.029	1.000	0.061	0.269	0.071	0.005
seller_type	0.229	0.108	0.018	0.248	0.072	0.169	0.061	1.000	0.282	0.373	0.185
selling_price	0.500	0.110	-0.358	0.650	-0.028	0.364	0.269	0.282	1.000	0.586	0.714
transmission	0.488	0.050	0.027	0.597	0.214	0.169	0.071	0.373	0.586	1.000	0.269
year	-0.003	0.122	-0.620	0.213	0.294	0.269	0.005	0.185	0.714	0.269	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

	name	year	selling_price	km_driven	fuel	seller_type	transmission	owner	mileage	engine	max_power	torque	seats
0	Maruti Swift Dzire VDI	2014	450000	145500	Diesel	Individual	Manual	First Owner	23.40	1248.0	74.00	190Nm@ 2000rpm	5.0
1	Skoda Rapid 1.5 TDI Ambition	2014	370000	120000	Diesel	Individual	Manual	Second Owner	21.14	1498.0	103.52	250Nm@ 1500-2500rpm	5.0
2	Hyundai i20 Sportz Diesel	2010	225000	127000	Diesel	Individual	Manual	First Owner	23.00	1396.0	90.00	22.4 kgm at 1750-2750rpm	5.0
3	Maruti Swift VXI BSIII	2007	130000	120000	Petrol	Individual	Manual	First Owner	16.10	1298.0	88.20	11.5@ 4,500(kgm@ rpm)	5.0
4	Hyundai Xcent 1.2 VTVT E Plus	2017	440000	45000	Petrol	Individual	Manual	First Owner	20.14	1197.0	81.86	113.75nm@ 4000rpm	5.0
5	Maruti Wagon R LXI DUO BSIII	2007	96000	175000	LPG	Individual	Manual	First Owner	17.30	1061.0	57.50	7.8@ 4,500(kgm@ rpm)	5.0
6	Maruti 800 DX BSII	2001	45000	5000	Petrol	Individual	Manual	Second Owner	16.10	796.0	37.00	59Nm@ 2500rpm	4.0
7	Toyota Etios VXD	2011	350000	90000	Diesel	Individual	Manual	First Owner	23.59	1364.0	67.10	170Nm@ 1800-2400rpm	5.0
8	Ford Figo Diesel Celebration Edition	2013	200000	169000	Diesel	Individual	Manual	First Owner	20.00	1399.0	68.10	160Nm@ 2000rpm	5.0
9	Renault Duster 110PS Diesel RxL	2014	500000	68000	Diesel	Individual	Manual	Second Owner	19.01	1461.0	108.45	248Nm@ 2250rpm	5.0

	name	year	selling_price	km_driven	fuel	seller_type	transmission	owner	mileage	engine	max_power	torque	seats
6989	Maruti Swift Dzire VDI	2015	625000	50000	Diesel	Individual	Manual	First Owner	26.59	1248.0	74.00	190Nm@ 2000rpm	5.0
6990	Hyundai i20 Magna	2013	380000	25000	Petrol	Individual	Manual	First Owner	18.50	1197.0	82.85	113.7Nm@ 4000rpm	5.0
6991	Maruti Wagon R LXI Optional	2017	360000	80000	Petrol	Individual	Manual	First Owner	20.51	998.0	67.04	90Nm@ 3500rpm	5.0
6992	Hyundai Santro Xing GLS	2008	120000	191000	Petrol	Individual	Manual	First Owner	17.92	1086.0	62.10	96.1Nm@ 3000rpm	5.0
6993	Maruti Wagon R VXI BS IV with ABS	2013	260000	50000	Petrol	Individual	Manual	Second Owner	18.90	998.0	67.10	90Nm@ 3500rpm	5.0
6994	Hyundai i20 Magna	2013	320000	110000	Petrol	Individual	Manual	First Owner	18.50	1197.0	82.85	113.7Nm@ 4000rpm	5.0
6995	Hyundai Verna CRDi SX	2007	135000	119000	Diesel	Individual	Manual	Fourth & Above Owner	16.80	1493.0	110.00	24@ 1,900-2,750(kgm@ rpm)	5.0
6996	Maruti Swift Dzire ZDi	2009	382000	120000	Diesel	Individual	Manual	First Owner	19.30	1248.0	73.90	190Nm@ 2000rpm	5.0
6997	Tata Indigo CR4	2013	290000	25000	Diesel	Individual	Manual	First Owner	23.57	1396.0	70.00	140Nm@ 1800-3000rpm	5.0
6998	Tata Indigo CR4	2013	290000	25000	Diesel	Individual	Manual	First Owner	23.57	1396.0	70.00	140Nm@ 1800-3000rpm	5.0

Most frequently occurring

	name	year	selling_price	km_driven	fuel	seller_type	transmission	owner	mileage	engine	max_power	torque	seats	# duplicates
64	Honda Amaze V CVT Petrol BSIV	2019	779000	7032	Petrol	Trustmark Dealer	Automatic	First Owner	19.00	1199.0	88.76	110Nm@ 4800rpm	5.0	30
192	Lexus ES 300h	2019	5150000	20000	Petrol	Dealer	Automatic	First Owner	22.37	2487.0	214.56	202Nm@ 3600-5200rpm	5.0	30
183	Jaguar XF 2.0 Diesel Portfolio	2017	3200000	45000	Diesel	Dealer	Automatic	First Owner	19.33	1999.0	177.00	430Nm@ 1750-2500rpm	5.0	28
467	Toyota Innova 2.5 VX (Diesel) 7 Seater	2013	750000	79328	Diesel	Trustmark Dealer	Manual	Second Owner	12.99	2494.0	100.60	200Nm@ 1200-3600rpm	7.0	28
13	BMW X4 M Sport X xDrive20d	2019	5400000	7500	Diesel	Dealer	Automatic	First Owner	16.78	1995.0	190.00	400Nm@ 1750-2500rpm	5.0	27
255	Maruti Baleno Alpha 1.3	2018	740000	38817	Diesel	Dealer	Manual	First Owner	27.39	1248.0	74.00	190Nm@ 2000rpm	5.0	27
306	Maruti Swift AMT ZXI	2018	600000	69779	Petrol	Dealer	Automatic	First Owner	22.00	1197.0	81.80	113Nm@ 4200rpm	5.0	27
363	Maruti Wagon R LXI	2013	225000	58343	Petrol	Trustmark Dealer	Manual	First Owner	21.79	998.0	67.05	90Nm@ 3500rpm	5.0	27
455	Toyota Etios VX	2017	625000	25538	Petrol	Trustmark Dealer	Manual	First Owner	16.78	1496.0	88.73	132Nm@ 3000rpm	5.0	27
114	Hyundai Grand i10 1.2 CRDi Sportz	2017	450000	56290	Diesel	Dealer	Manual	First Owner	24.00	1186.0	73.97	190.24nm@ 1750-2250rpm	5.0	26

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Interactions

Correlations

Missing values

Sample

Duplicate rows

Most frequently occurring